Spread WPF Documentation
Evaluate(Object[]) Method


The args contains 2 - 3 items: range, criteria, [sum_range].

Range is the range of cells that you want evaluated by criteria.

Criteria is the criteria in the form of a number, expression, or text that defines which cells will be added.

[Sum_range] are the actual cells to add if their corresponding cells in range match criteria.

Adds the cells specified by a given criteria.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object
'Usage
 
Dim instance As CalcSumIfFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)
public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 2 - 3 items: range, criteria, [sum_range].

Range is the range of cells that you want evaluated by criteria.

Criteria is the criteria in the form of a number, expression, or text that defines which cells will be added.

[Sum_range] are the actual cells to add if their corresponding cells in range match criteria.

Return Value

A System.Double value that indicates the evaluate result.
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

CalcSumIfFunction Class
CalcSumIfFunction Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.